package com.spring.shops.dao;

import com.spring.shops.model.entity.TzTransfeeFree;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TzTransfeeFreeMapper {
    int deleteByPrimaryKey(Long transfeeFreeId);

    int insert(TzTransfeeFree record);

    int insertSelective(TzTransfeeFree record);

    TzTransfeeFree selectByPrimaryKey(Long transfeeFreeId);

    int updateByPrimaryKeySelective(TzTransfeeFree record);

    int updateByPrimaryKey(TzTransfeeFree record);

    /**
     * 根据运费模板id获取所有的免运费项
     * @param id
     * @return
     */
    @Select("select * from yami_shops.tz_transfee_free where transport_id=#{id}")
    List<TzTransfeeFree> selectByTransId(Long id);
}